/*--------------------------------------------------------------
-- Use the next lines if you want to drop/create database

use [master]
go

drop database [FlowUsers]
go

create database [FlowUsers]
go

use [FlowUsers]
go
*/

IF (EXISTS (SELECT 1 FROM INFORMATION_SCHEMA.TABLES where TABLE_NAME = 'AddressDetails'))
BEGIN
	RAISERROR ('The database is not empty, please drop the database before running this script', 15, 1)
END


/*--------------------------------------------------------------

CREATE DATABASE

--------------------------------------------------------------*/

CREATE TABLE [dbo].[AddressDetails] (
    [AddressDetailsId] [int] NOT NULL IDENTITY,
    [Address] [nvarchar](200),
    [City] [nvarchar](50),
    [Region] [nvarchar](50),
    [PostalCode] [nvarchar](20),
    [Country] [nvarchar](50),
    CONSTRAINT [PK_dbo.AddressDetails] PRIMARY KEY ([AddressDetailsId])
)
CREATE TABLE [dbo].[Domain] (
    [DomainId] [int] NOT NULL IDENTITY,
    [Name] [nvarchar](50) NOT NULL,
    [Phone] [nvarchar](20),
    [Fax] [nvarchar](20),
    [Email] [nvarchar](256),
    [AddressDetailsId] [int],
    [DateCreated] [datetime] NOT NULL,
    [DateLastUpdated] [datetime] NOT NULL,
    CONSTRAINT [PK_dbo.Domain] PRIMARY KEY ([DomainId])
)
CREATE TABLE [dbo].[DomainUser] (
    [DomainUserId] [int] NOT NULL IDENTITY,
    [UserId] [int] NOT NULL,
    [DomainId] [int] NOT NULL,
    CONSTRAINT [PK_dbo.DomainUser] PRIMARY KEY ([DomainUserId])
)
CREATE TABLE [dbo].[User] (
    [UserId] [int] NOT NULL IDENTITY,
    [Name] [nvarchar](16) NOT NULL,
    [Email] [nvarchar](256) NOT NULL,
    [Password] [nvarchar](100) NOT NULL,
    [IsActive] [bit] NOT NULL,
    [FirstName] [nvarchar](50),
    [LastName] [nvarchar](50),
    [Title] [nvarchar](5),
    [Gender] [nvarchar](5),
    [Birthday] [datetime],
    [Photo] [varbinary](max),
    [PhotoPath] [nvarchar](256),
    [Note] [nvarchar](600),
    [HomePhone] [nvarchar](20),
    [MobilePhone] [nvarchar](20),
    [WorkPhone] [nvarchar](20),
    [Position] [nvarchar](50),
    [Department] [nvarchar](50),
    [HireDate] [datetime],
    [OnlineStatusId] [int],
    [AddressDetailsId] [int],
    [DateCreated] [datetime] NOT NULL,
    [DateLastUpdated] [datetime] NOT NULL,
    CONSTRAINT [PK_dbo.User] PRIMARY KEY ([UserId])
)
CREATE TABLE [dbo].[OnlineStatus] (
    [OnlineStatusId] [int] NOT NULL IDENTITY,
    [Code] [nvarchar](50) NOT NULL,
    [Description] [nvarchar](200),
    CONSTRAINT [PK_dbo.OnlineStatus] PRIMARY KEY ([OnlineStatusId])
)
CREATE TABLE [dbo].[Resource] (
    [ResourceId] [int] NOT NULL IDENTITY,
    [Type] [nvarchar](max),
    [Display] [nvarchar](max),
    [Value] [nvarchar](max),
    [Order] [int] NOT NULL,
    [Description] [nvarchar](max),
    [RoleId] [int],
    CONSTRAINT [PK_dbo.Resource] PRIMARY KEY ([ResourceId])
)
CREATE TABLE [dbo].[Role] (
    [RoleId] [int] NOT NULL IDENTITY,
    [Name] [nvarchar](20) NOT NULL,
    [Description] [nvarchar](200),
    [DateCreated] [datetime] NOT NULL,
    [DateLastUpdated] [datetime] NOT NULL,
    CONSTRAINT [PK_dbo.Role] PRIMARY KEY ([RoleId])
)
CREATE TABLE [dbo].[RoleUser] (
    [RoleUserId] [int] NOT NULL IDENTITY,
    [IsPrimary] [bit] NOT NULL,
    [UserId] [int] NOT NULL,
    [RoleId] [int] NOT NULL,
    CONSTRAINT [PK_dbo.RoleUser] PRIMARY KEY ([RoleUserId])
)
CREATE TABLE [dbo].[UserFollowing] (
    [UserFollowingId] [int] NOT NULL IDENTITY,
    [FoolowerUserId] [int] NOT NULL,
    [FollowingUserId] [int] NOT NULL,
    CONSTRAINT [PK_dbo.UserFollowing] PRIMARY KEY ([UserFollowingId])
)
CREATE INDEX [IX_AddressDetailsId] ON [dbo].[Domain]([AddressDetailsId])
CREATE INDEX [IX_DomainId] ON [dbo].[DomainUser]([DomainId])
CREATE INDEX [IX_AddressDetailsId] ON [dbo].[User]([AddressDetailsId])
CREATE INDEX [IX_OnlineStatusId] ON [dbo].[User]([OnlineStatusId])
CREATE INDEX [IX_UserId] ON [dbo].[DomainUser]([UserId])
CREATE INDEX [IX_RoleId] ON [dbo].[Resource]([RoleId])
CREATE INDEX [IX_RoleId] ON [dbo].[RoleUser]([RoleId])
CREATE INDEX [IX_UserId] ON [dbo].[RoleUser]([UserId])
CREATE INDEX [IX_FoolowerUserId] ON [dbo].[UserFollowing]([FoolowerUserId])
CREATE INDEX [IX_FollowingUserId] ON [dbo].[UserFollowing]([FollowingUserId])
ALTER TABLE [dbo].[Domain] ADD CONSTRAINT [FK_dbo.Domain_dbo.AddressDetails_AddressDetailsId] FOREIGN KEY ([AddressDetailsId]) REFERENCES [dbo].[AddressDetails] ([AddressDetailsId])
ALTER TABLE [dbo].[DomainUser] ADD CONSTRAINT [FK_dbo.DomainUser_dbo.Domain_DomainId] FOREIGN KEY ([DomainId]) REFERENCES [dbo].[Domain] ([DomainId]) ON DELETE CASCADE
ALTER TABLE [dbo].[DomainUser] ADD CONSTRAINT [FK_dbo.DomainUser_dbo.User_UserId] FOREIGN KEY ([UserId]) REFERENCES [dbo].[User] ([UserId]) ON DELETE CASCADE
ALTER TABLE [dbo].[User] ADD CONSTRAINT [FK_dbo.User_dbo.AddressDetails_AddressDetailsId] FOREIGN KEY ([AddressDetailsId]) REFERENCES [dbo].[AddressDetails] ([AddressDetailsId])
ALTER TABLE [dbo].[User] ADD CONSTRAINT [FK_dbo.User_dbo.OnlineStatus_OnlineStatusId] FOREIGN KEY ([OnlineStatusId]) REFERENCES [dbo].[OnlineStatus] ([OnlineStatusId])
ALTER TABLE [dbo].[Resource] ADD CONSTRAINT [FK_dbo.Resource_dbo.Role_RoleId] FOREIGN KEY ([RoleId]) REFERENCES [dbo].[Role] ([RoleId])
ALTER TABLE [dbo].[RoleUser] ADD CONSTRAINT [FK_dbo.RoleUser_dbo.Role_RoleId] FOREIGN KEY ([RoleId]) REFERENCES [dbo].[Role] ([RoleId]) ON DELETE CASCADE
ALTER TABLE [dbo].[RoleUser] ADD CONSTRAINT [FK_dbo.RoleUser_dbo.User_UserId] FOREIGN KEY ([UserId]) REFERENCES [dbo].[User] ([UserId]) ON DELETE CASCADE
ALTER TABLE [dbo].[UserFollowing] ADD CONSTRAINT [FK_dbo.UserFollowing_dbo.User_FoolowerUserId] FOREIGN KEY ([FoolowerUserId]) REFERENCES [dbo].[User] ([UserId])
ALTER TABLE [dbo].[UserFollowing] ADD CONSTRAINT [FK_dbo.UserFollowing_dbo.User_FollowingUserId] FOREIGN KEY ([FollowingUserId]) REFERENCES [dbo].[User] ([UserId])
CREATE TABLE [dbo].[__MigrationHistory] (
    [MigrationId] [nvarchar](150) NOT NULL,
    [ContextKey] [nvarchar](300) NOT NULL,
    [Model] [varbinary](max) NOT NULL,
    [ProductVersion] [nvarchar](32) NOT NULL,
    CONSTRAINT [PK_dbo.__MigrationHistory] PRIMARY KEY ([MigrationId], [ContextKey])
)
INSERT [dbo].[__MigrationHistory]([MigrationId], [ContextKey], [Model], [ProductVersion])
VALUES (N'201406261114321_AutomaticMigration', N'Flow.Users.Data.Migrations.Configuration',  0x1F8B0800000000000400ED5D5B6F1CB7157E2FD0FFB0D8A7B640B492031B89B14A604B562324B20CAD9C3C1AD40E250D3297ED0CD7967E5B1FFA93FA174ACE95F7DB7066775DBF181687FC7878F8F1903CE41EFEF7DFFF59FEFC9426B3CFB028E33C3B9D9F1C1DCF67305BE7519C3D9CCEB7E8FEBB1FE63FFFF4D7BF2CDF45E9D3ECF736DFF7241F2E9995A7F3478436AF178B72FD0853501EA5F1BAC8CBFC1E1DADF37401A27CF1E2F8F8C7C5C9C902628839C69ACD9637DB0CC529ACFEC07F9EE5D91A6ED0162457790493B249C75F5615EAEC3D4861B9016B783ABF48F22F471F4B2CC9D13940603E7B93C4008BB182C9FD7C06B22C470061215FE33C2B54E4D9C36A83134072FBBC8138DF3D484AD808FFBACF6EDB8EE317A41D8BBEA0971EE65D0B711BDF615DA067225ED5CED3F99B282A60599E4304E2A4A4F3E2DCBFC2672601277D28F20D2CD0F30DBC97225C46F3D9824559F0301D88128108783ABFCCD0F72FE6B3F7DB24017709ECF449297E85F202FE1366B00008461F0042B0C0FABD8C60D550411679CD6D85B80F3117E7B32BF0F41BCC1ED0E3E91C2B723EBB889F60D4A634427CCC624C5D5C08155B68AAE7AC924559C9CB1075DCC0878A22E3D6F2212F1148CE707EADD242E82CC703B708ACB6E5A21F01DA71719EA720CE7CC6435DD2671CF425A7E23FF977B88205010D147ACCB3D1D973019EC6AEE21DEEAD4457C9CB57016A3118477D613C6BC1B302126EB4E548D26D9CBA771B29F81B28D1C74DE487F71E7C8E1F2ADA6A9B389FDDC0A4CA563EC69B7AB23DAA87C6273EE74591A73779D28D1D2EC3A755BE2DD6846BB92ED72D281E201A6428C822C1DF5890D2FE06A32D3D95D1B0ABCF40264B53674BA1C65CABA94384FED4E6E269437D545086CE21A38B4EB68A1B06C9EA3C52B9AA7F345255FF0CA2B02F797D693B35610DB3DC899D99766478A8D9C175720565F9252F225D7B2D97B48E355F966FD628FEDC69FA6D8E990A32679C8BB82851988589BE2232994D51CF6D8C126D2501EAC08323221664D44ADEC6057A8CC0B338F51B177C28EF68116780ACEA29D9AEC85A4D269D052C36068FA3AFC1DEE748D781AF82EC117FC95338C9D2F82ABF8B9369AAFA232FFE9CA422BC2D8DD104DBDF73B801054AF1BC33764DBFC4052403CC75B05D67499CC1159E39B7AEBB856F5B0DB22AABD653EA8D86E4B3B03A93E5715D35D2FDA89693CDC549497F94CBC8E418B4866404F1584BF2B4755D536A693FE2DAD2E0091BC783720ECB75116F0C06CFC77569DDDF37B0AC09E5D1D76D599F7EA6CB4ED5C7A41E8D9E95CB17B799252E3709D0B93BC3D4F33B48B6E3B7E6BAA096A39E2E022B928711979844D37CA7B4D4A4B0D442B75CFD54E7E8AD33F341B0CCECD74156B9AAD8678436FA701E9D323DEE6E676FB9B4DC1BEBBBCFAB2A27CEF97A94DAB2BEDC9BDAB374597E28E214F4A754BE4E8F103E55BBC137DCAA357A16AD1AFD41B46ACCD7603ED40E96F7A0321FD4D284F19E5EE449927F2126C0D38DDA01F8FA531980A9E87F81D99E7F814508F6760DF0025312A786AD45546EA3BABA3FB1D9D9FD943C977463A5C8EACA7A4627D6D277F9F5E237D9ACE46FF3BA0C94376599AFE34A60E69086DF5BB3BA78974533AB13BD7ADEED8F51F0E4BB4D50BC49E23516E674FE0F41CD26E8B6711434EF0660AB383E3A3A116AC1E31A1664F8905B1259890A5C13128D409CADE30D486C04E20A7B5DC221DDD455CA7F39871BE23ECE908DE64349D355CA193B93FE960B8A58367CA34FFEF484901E03F23CAB87962BD764E787460A9FF0CA5E5E67E7308108CEC8510BB9487606CA3588447B88C764148C9712E16D58A0BA08E3C14549CF0C956002FEC93C892A9A68DD8A3D515CD9A7F344EEC0CE69C499DCCA69347E40364EF4026BA92077090FE497D48B4C81B24EEA51B92513C5A637F5EE67775EC9F41C468E69E74DC9465E3AB5B12BC9807326B3EC341075AFE64B5A709B9E97BB3D7CE74ABA3F86D53E01DF583FA98A140AA7694F89EE48C28169725F2B0D5A3939C6B259D2EA6DFA4BEEA075628B549FC3EA9E822B8CF749D9AD725714DBADAE5649EEC1327065F736492AF6541C93F5C3E1704C3BFB291C8C81387658F39E54EC89663D693FECFD9CA7713BEAD6DA261F244B94DE2DEDB8A437F82F8D7C0CB6A0D70B3211C3CC8AB711847796EF0DED5A7FB10B2104E7F148C4E31DCFBB631E27C90EA9C7E9DE8E7BDCE1CA04E4AB4F057019844BC0A29504CB418428ABCF3114FD15A4D40A22D6CD82F3CDFA630685D74A60160B556F8F6440ADFBD50AA0925E0952B3D200A482B02A4CBB08A46A61DD2D06B476172003EA37542610CC552940B520B628AC5248BF84B2D0684772956A29ABC4C15114E6BB5BB80A4AE5D5FE388D1F61B6275B5DD328C60AC3D5F62C8B02A34612BF08649B6FAD1AFA6445A916E5F18BCAE3C31DC008EA68B8625489ECC8C5AC5B0F65C8DCFC1275184F03ACCF03A8569895A13B0118891DA24F5AA50EB5E3DAD275EDAE0AA9B39A82E1CD6BC8B1529B32ED48115762562ED761A38459629954EAA102EE22A4A8008D07D0C20748494C4D679AA6CBBD7E344C3DA10D6F387B574AD270B53BCBC2A1C5496CEE73B90B6BCC86AB28AFF1B1587859FC1B3E36D535FB7A8511B4F102B8FA01B886D12B23837D34ECFC27D2587785C94E65D21DACF31E369CD2F85DEB00ADB5B7ABBA7D54F76DB9A803163509CB8522B2D1F20A6C36A4197DC92665B6AAC31C9D7DB7728F2C94D6188B353371F3BBBEAE269417E001725FEB9FCF543FF825F195EE00B9D97716A54236EB5D635B1FBF7914FBAFDD1FB425C8FFFB2D2A15F589DF668AFBED06E202B790FC32B06A2C14D7564A8019893D051250187F8F779627DB34B3BD8060449602BAE0D4718D689033C9B5511D421BB588C668D3EC51E8A84434129DEED0AA36F210D3B03651C4592E380608CE15816E82179EE5AF15BBDB1DCC106ECB3766169C561554E9B4BF8A452B557D414B8D54FFE68346A9531CD852FF2299214A9D648F51C517A211AA04FBF24D78081AA149721EC523D807E667274C87D11FDCF0989F9EF098CCC73D1B61F5943D7C94C99628D6234D5E583FDA5A67AF38E2546E6035A20CCB1DC5DD0AECA8E787F7B9676FBBF573985E196E514358B33E720D6398BB547BA43E120D8DD4A73A58F93E160D63EBFB647BAC3EDC0C0DD5A7DA23350165689826C91EA30D184383B469F6287D44181AA74F759A93498C186E4E26498E1875401801A74E76181355C817664C5429F608543C171A864AB6C76242B6D068CC077B3C2A2E0B8D46253BADBD9BD02BDCCABB4975981DA8E02ACCFC40A53BE8BF0BA0C2A8BF4BB547E22FE5D278A60BBB6AD46FABB7FEFB287338E7C91F3299EBCE292C26757DF16969276E925DB7C7CCEFDFD9714A7DD81B1AF447024318208F7762D5FBEAA26AA7481FE484758CA802A7E8D0EAF025CC6AA14A71E8F1363609D3DB6DA23D4E137B844669921C8C7121AC5B9AA4F119ACECAFE6B62AD3578A1BACBB1B07D5D1CEA0312039A3B2E1BFB458185D8EB7A509CD916F9372D795C337D7DDBD203F36BA6DB2DB123256BA6FB6A99021ECEEB44B9EDA297310D68B3B911BEA995104ECB06290A1BCAEB398281D7CAF696280E870F97BC58CA3C270E75887CADD1865610DD74947A6897028CA67E96AEF0E47B943D0657320697E034638A1ACB3CC6758619FE3889C4EAE9E4B04D39A5CAB7F2567495C6D55DB0C57208BEF61896EF33F61560586FA817B49C6E35597455946C9E13EED12130519A3CF388690E15E73C93E8362FD080A312C578FEBFA788B14F3A53324FB564B2050F1691685069C15C0BEC4E225EE413DBC320A3BEB05A8B50ADD9F5209D4DBD4CB2981109950F8724C12A6DB0D546B59DCA02441F6C8B219050CB2678977B0AF8E8C326224550C7C66C48C71208F66ECC6429DBC72C6741EFB5EAF5CC8A53D7637A8FC231677B13BE984072C02CDEFFC7B15816099E729E498AE90EC6B146130F9C7276416D56A95443F468125BBABDEA3F85B0A9EFEEE05453F40116A6EA3DF9B9062BE725FC50ACF4B049ADC25AF490442161E8F0884CBBF1511681C894F430402E65F82F065BE3C44BEC77AE9FF7BE9B59F2F1D8CB22030EE253DB62C92E8D97E1BF5037CAA60944EAA0FF3584D7A4D67DC0B0483B09857060621312F0978ED01D484F312A8758D5BDABC0389D5BF9B0DC58B1DDA8FAF6232929F66ED22D8FE280412E2EBFBECC786BB11B4437EA813612F63C78FD29BF270F13E1DA20816EFDF33438395F33FFFD74429B18825C8FF48DB2BDCB957E41BE36FDDDC0F8966EE212C0F2900AF6B90F1A9E37ECB7EF0EF1DA2754050D45D840CFFDA82848F6565044E8CC8865D5B186B5EEC897D31C449A17A918DB8A20C08B5B7CC305CB276F5A48CC38A830AD06DD57B5FD96C63DD93AABB4BE3CD34EA1AF727C8764E3D55EE14FF5A8CAEE3199CDB3B00EDD481B30F2890F1F03E1FC94AF401FEA451FF0E9F2BEA8BCAFBCA95BD9D5176C19529671327AEEC742EB10D5BE54E1CFD4A940AE0A90EED79F03C30DD4F172B3DE8D0D2DF58311A2BF625E8B318E58BEF4F69D0E7CE99D1FB6C15DE8EFA4EFEE93CBA23577B6AEFAF5774684D7068591DCE81A30D71A3D575D4DF0DF5286A50635BA1B2EE03019DFD2CABC52B20B5361EB5AC16A768D5CA60D552649730D6DA28D62A74EBDEA52C9AB49BA9EFAAFEDE9728D8F2412E0B98271A2ED1A94E95560CCABD89726D21ACD29322949432674F625887E961A1E1219B1C324AB5CC4E8AE11F76D1D4A021A8AD849C9CC0E1424C53B343FFF3755DF3F8198B0DFA10A0692183483B368D9BD4D85F50076C9A8A96B661A2DD493976D3347BE49081A0DD1A2D5D42487ED43C4EF34789EABC6B05380468167F738C775ADB8CDC07ABFF3A8765FCD0432C316606D7CC1EABCB7399DDE7ED9E8F93A8CDC2DFD4C7936D8437606F0A14DF8335C29FD7780EAE9A5BDDD724BFD6B983D16576BD459B2DC24D86E95DC24424205B465DFD55146A56E6E5757559AF0CD1042C664CAED05D676FB7711275725F486EFA2820C85EB4B9D344FA1291BB4D0FCF1DD27B21FA990AA8515FB785BE85E926C160E575B602E417442AD9CC3A6435B63C8FC14301D2B2C1E8CBE33F31FDA2F4E9A7FF0193C953985FA50000 , N'6.0.2-21211')


exec sp_executesql N'INSERT [dbo].[AddressDetails]([Address], [City], [Region], [PostalCode], [Country])
VALUES (@0, @1, @2, @3, @4)
SELECT [AddressDetailsId]
FROM [dbo].[AddressDetails]
WHERE @@ROWCOUNT > 0 AND [AddressDetailsId] = scope_identity()',N'@0 nvarchar(200),@1 nvarchar(50),@2 nvarchar(50),@3 nvarchar(20),@4 nvarchar(50)',@0=N'11 aa',@1=N'Macondo',@2=N'America',@3=N'21456',@4=N'America'
go
exec sp_executesql N'INSERT [dbo].[Domain]([Name], [Phone], [Fax], [Email], [AddressDetailsId], [DateCreated], [DateLastUpdated])
VALUES (@0, NULL, NULL, NULL, NULL, @1, @2)
SELECT [DomainId]
FROM [dbo].[Domain]
WHERE @@ROWCOUNT > 0 AND [DomainId] = scope_identity()',N'@0 nvarchar(50),@1 datetime2(7),@2 datetime2(7)',@0=N'AcmeStar',@1='2014-05-14 22:33:37.0726601',@2='2014-05-14 22:33:37.0726601'
go
exec sp_executesql N'INSERT [dbo].[OnlineStatus]([Code], [Description])
VALUES (@0, @1)
SELECT [OnlineStatusId]
FROM [dbo].[OnlineStatus]
WHERE @@ROWCOUNT > 0 AND [OnlineStatusId] = scope_identity()',N'@0 nvarchar(50),@1 nvarchar(200)',@0=N'Online',@1=N'User is online'
go
exec sp_executesql N'INSERT [dbo].[OnlineStatus]([Code], [Description])
VALUES (@0, @1)
SELECT [OnlineStatusId]
FROM [dbo].[OnlineStatus]
WHERE @@ROWCOUNT > 0 AND [OnlineStatusId] = scope_identity()',N'@0 nvarchar(50),@1 nvarchar(200)',@0=N'Offline',@1=N'User is offline'
go
exec sp_executesql N'INSERT [dbo].[OnlineStatus]([Code], [Description])
VALUES (@0, @1)
SELECT [OnlineStatusId]
FROM [dbo].[OnlineStatus]
WHERE @@ROWCOUNT > 0 AND [OnlineStatusId] = scope_identity()',N'@0 nvarchar(50),@1 nvarchar(200)',@0=N'Busy',@1=N'User is busy'
go
exec sp_executesql N'INSERT [dbo].[Resource]([Type], [Display], [Value], [Order], [Description], [RoleId])
VALUES (@0, @1, @2, @3, NULL, NULL)
SELECT [ResourceId]
FROM [dbo].[Resource]
WHERE @@ROWCOUNT > 0 AND [ResourceId] = scope_identity()',N'@0 nvarchar(max) ,@1 nvarchar(max) ,@2 nvarchar(max) ,@3 int',@0=N'page',@1=N'Home',@2=N'#',@3=1
go
exec sp_executesql N'INSERT [dbo].[Resource]([Type], [Display], [Value], [Order], [Description], [RoleId])
VALUES (@0, @1, @2, @3, NULL, NULL)
SELECT [ResourceId]
FROM [dbo].[Resource]
WHERE @@ROWCOUNT > 0 AND [ResourceId] = scope_identity()',N'@0 nvarchar(max) ,@1 nvarchar(max) ,@2 nvarchar(max) ,@3 int',@0=N'page',@1=N'Task',@2=N'#/tasks',@3=2
go
exec sp_executesql N'INSERT [dbo].[Resource]([Type], [Display], [Value], [Order], [Description], [RoleId])
VALUES (@0, @1, @2, @3, NULL, NULL)
SELECT [ResourceId]
FROM [dbo].[Resource]
WHERE @@ROWCOUNT > 0 AND [ResourceId] = scope_identity()',N'@0 nvarchar(max) ,@1 nvarchar(max) ,@2 nvarchar(max) ,@3 int',@0=N'page',@1=N'Holidays',@2=N'#/holidays',@3=6
go
exec sp_executesql N'INSERT [dbo].[Role]([Name], [Description], [DateCreated], [DateLastUpdated])
VALUES (@0, @1, @2, @3)
SELECT [RoleId]
FROM [dbo].[Role]
WHERE @@ROWCOUNT > 0 AND [RoleId] = scope_identity()',N'@0 nvarchar(20),@1 nvarchar(200),@2 datetime2(7),@3 datetime2(7)',@0=N'MgrDev',@1=N'Role description',@2='2014-05-14 22:33:37.0726601',@3='2014-05-14 22:33:37.0726601'
go
exec sp_executesql N'INSERT [dbo].[Role]([Name], [Description], [DateCreated], [DateLastUpdated])
VALUES (@0, @1, @2, @3)
SELECT [RoleId]
FROM [dbo].[Role]
WHERE @@ROWCOUNT > 0 AND [RoleId] = scope_identity()',N'@0 nvarchar(20),@1 nvarchar(200),@2 datetime2(7),@3 datetime2(7)',@0=N'Admin',@1=N'Role description',@2='2014-05-14 22:33:37.0726601',@3='2014-05-14 22:33:37.0726601'
go
exec sp_executesql N'INSERT [dbo].[Resource]([Type], [Display], [Value], [Order], [Description], [RoleId])
VALUES (@0, @1, @2, @3, NULL, @4)
SELECT [ResourceId]
FROM [dbo].[Resource]
WHERE @@ROWCOUNT > 0 AND [ResourceId] = scope_identity()',N'@0 nvarchar(max) ,@1 nvarchar(max) ,@2 nvarchar(max) ,@3 int,@4 int',@0=N'page',@1=N'Dashboard',@2=N'#/dashboard',@3=3,@4=2
go
exec sp_executesql N'INSERT [dbo].[Role]([Name], [Description], [DateCreated], [DateLastUpdated])
VALUES (@0, @1, @2, @3)
SELECT [RoleId]
FROM [dbo].[Role]
WHERE @@ROWCOUNT > 0 AND [RoleId] = scope_identity()',N'@0 nvarchar(20),@1 nvarchar(200),@2 datetime2(7),@3 datetime2(7)',@0=N'Approver',@1=N'Role description',@2='2014-05-14 22:33:37.0726601',@3='2014-05-14 22:33:37.0726601'
go
exec sp_executesql N'INSERT [dbo].[Role]([Name], [Description], [DateCreated], [DateLastUpdated])
VALUES (@0, @1, @2, @3)
SELECT [RoleId]
FROM [dbo].[Role]
WHERE @@ROWCOUNT > 0 AND [RoleId] = scope_identity()',N'@0 nvarchar(20),@1 nvarchar(200),@2 datetime2(7),@3 datetime2(7)',@0=N'Dev',@1=N'Role description',@2='2014-05-14 22:33:37.0726601',@3='2014-05-14 22:33:37.0726601'
go
exec sp_executesql N'INSERT [dbo].[Role]([Name], [Description], [DateCreated], [DateLastUpdated])
VALUES (@0, @1, @2, @3)
SELECT [RoleId]
FROM [dbo].[Role]
WHERE @@ROWCOUNT > 0 AND [RoleId] = scope_identity()',N'@0 nvarchar(20),@1 nvarchar(200),@2 datetime2(7),@3 datetime2(7)',@0=N'MgrBA',@1=N'Role description',@2='2014-05-14 22:33:37.0726601',@3='2014-05-14 22:33:37.0726601'
go
exec sp_executesql N'INSERT [dbo].[Resource]([Type], [Display], [Value], [Order], [Description], [RoleId])
VALUES (@0, @1, @2, @3, NULL, @4)
SELECT [ResourceId]
FROM [dbo].[Resource]
WHERE @@ROWCOUNT > 0 AND [ResourceId] = scope_identity()',N'@0 nvarchar(max) ,@1 nvarchar(max) ,@2 nvarchar(max) ,@3 int,@4 int',@0=N'page',@1=N'Sketch',@2=N'#/sketch',@3=4,@4=5
go
exec sp_executesql N'INSERT [dbo].[Role]([Name], [Description], [DateCreated], [DateLastUpdated])
VALUES (@0, @1, @2, @3)
SELECT [RoleId]
FROM [dbo].[Role]
WHERE @@ROWCOUNT > 0 AND [RoleId] = scope_identity()',N'@0 nvarchar(20),@1 nvarchar(200),@2 datetime2(7),@3 datetime2(7)',@0=N'BA',@1=N'Role description',@2='2014-05-14 22:33:37.0726601',@3='2014-05-14 22:33:37.0726601'
go
exec sp_executesql N'INSERT [dbo].[Resource]([Type], [Display], [Value], [Order], [Description], [RoleId])
VALUES (@0, @1, @2, @3, NULL, @4)
SELECT [ResourceId]
FROM [dbo].[Resource]
WHERE @@ROWCOUNT > 0 AND [ResourceId] = scope_identity()',N'@0 nvarchar(max) ,@1 nvarchar(max) ,@2 nvarchar(max) ,@3 int,@4 int',@0=N'page',@1=N'Sketch',@2=N'#/sketch',@3=4,@4=6
go
exec sp_executesql N'INSERT [dbo].[Role]([Name], [Description], [DateCreated], [DateLastUpdated])
VALUES (@0, @1, @2, @3)
SELECT [RoleId]
FROM [dbo].[Role]
WHERE @@ROWCOUNT > 0 AND [RoleId] = scope_identity()',N'@0 nvarchar(20),@1 nvarchar(200),@2 datetime2(7),@3 datetime2(7)',@0=N'Finance',@1=N'Role description',@2='2014-05-14 22:33:37.0726601',@3='2014-05-14 22:33:37.0726601'
go
exec sp_executesql N'INSERT [dbo].[Role]([Name], [Description], [DateCreated], [DateLastUpdated])
VALUES (@0, @1, @2, @3)
SELECT [RoleId]
FROM [dbo].[Role]
WHERE @@ROWCOUNT > 0 AND [RoleId] = scope_identity()',N'@0 nvarchar(20),@1 nvarchar(200),@2 datetime2(7),@3 datetime2(7)',@0=N'MgrFinance',@1=N'Role description',@2='2014-05-14 22:33:37.0726601',@3='2014-05-14 22:33:37.0726601'
go
exec sp_executesql N'INSERT [dbo].[Role]([Name], [Description], [DateCreated], [DateLastUpdated])
VALUES (@0, @1, @2, @3)
SELECT [RoleId]
FROM [dbo].[Role]
WHERE @@ROWCOUNT > 0 AND [RoleId] = scope_identity()',N'@0 nvarchar(20),@1 nvarchar(200),@2 datetime2(7),@3 datetime2(7)',@0=N'PM',@1=N'Role description',@2='2014-05-14 22:33:37.0726601',@3='2014-05-14 22:33:37.0726601'
go

exec sp_executesql N'INSERT [dbo].[Role]([Name], [Description], [DateCreated], [DateLastUpdated])
VALUES (@0, @1, @2, @3)
SELECT [RoleId]
FROM [dbo].[Role]
WHERE @@ROWCOUNT > 0 AND [RoleId] = scope_identity()',N'@0 nvarchar(20),@1 nvarchar(200),@2 datetime2(7),@3 datetime2(7)',@0=N'MgrPM',@1=N'Role description',@2='2014-05-14 22:33:37.0726601',@3='2014-05-14 22:33:37.0726601'
go
exec sp_executesql N'INSERT [dbo].[Resource]([Type], [Display], [Value], [Order], [Description], [RoleId])
VALUES (@0, @1, @2, @3, NULL, @4)
SELECT [ResourceId]
FROM [dbo].[Resource]
WHERE @@ROWCOUNT > 0 AND [ResourceId] = scope_identity()',N'@0 nvarchar(max) ,@1 nvarchar(max) ,@2 nvarchar(max) ,@3 int,@4 int',@0=N'page',@1=N'Report',@2=N'#/report',@3=5,@4=9
go
exec sp_executesql N'INSERT [dbo].[Resource]([Type], [Display], [Value], [Order], [Description], [RoleId])
VALUES (@0, @1, @2, @3, NULL, @4)
SELECT [ResourceId]
FROM [dbo].[Resource]
WHERE @@ROWCOUNT > 0 AND [ResourceId] = scope_identity()',N'@0 nvarchar(max) ,@1 nvarchar(max) ,@2 nvarchar(max) ,@3 int,@4 int',@0=N'page',@1=N'Report',@2=N'#/report',@3=5,@4=10
go

exec sp_executesql N'INSERT [dbo].[Role]([Name], [Description], [DateCreated], [DateLastUpdated])
VALUES (@0, @1, @2, @3)
SELECT [RoleId]
FROM [dbo].[Role]
WHERE @@ROWCOUNT > 0 AND [RoleId] = scope_identity()',N'@0 nvarchar(20),@1 nvarchar(200),@2 datetime2(7),@3 datetime2(7)',@0=N'HR',@1=N'Role description',@2='2014-05-14 22:33:37.0726601',@3='2014-05-14 22:33:37.0726601'
go
exec sp_executesql N'INSERT [dbo].[Role]([Name], [Description], [DateCreated], [DateLastUpdated])
VALUES (@0, @1, @2, @3)
SELECT [RoleId]
FROM [dbo].[Role]
WHERE @@ROWCOUNT > 0 AND [RoleId] = scope_identity()',N'@0 nvarchar(20),@1 nvarchar(200),@2 datetime2(7),@3 datetime2(7)',@0=N'MgrHR',@1=N'Role description',@2='2014-05-14 22:33:37.0726601',@3='2014-05-14 22:33:37.0726601'
go
exec sp_executesql N'INSERT [dbo].[User]([Name], [Email], [Password], [IsActive], [FirstName], [LastName], [Title], [Gender], [Birthday], [Photo], [PhotoPath], [Note], [HomePhone], [MobilePhone], [WorkPhone], [Position], [Department], [HireDate], [OnlineStatusId], [AddressDetailsId], [DateCreated], [DateLastUpdated])
VALUES (@0, @1, @2, @3, @4, @5, NULL, NULL, NULL, NULL, @6, NULL, NULL, NULL, NULL, @7, @8, NULL, NULL, NULL, @9, @10)
SELECT [UserId]
FROM [dbo].[User]
WHERE @@ROWCOUNT > 0 AND [UserId] = scope_identity()',N'@0 nvarchar(16),@1 nvarchar(256),@2 nvarchar(16),@3 bit,@4 nvarchar(50),@5 nvarchar(50),@6 nvarchar(256),@7 nvarchar(50),@8 nvarchar(50),@9 datetime2(7),@10 datetime2(7)',@0=N'cgrant',@1=N'cgrant@aa.com',@2=N'I/Wn9e+RVG0=',@3=1,@4=N'Cary',@5=N'Grant',@6=N'Images\users\cgrant.jpg',@7=N'Developer Manager',@8=N'IT',@9='2014-05-14 22:33:37.0726601',@10='2014-05-14 22:33:37.0726601'
go
exec sp_executesql N'INSERT [dbo].[DomainUser]([UserId], [DomainId])
VALUES (@0, @1)
SELECT [DomainUserId]
FROM [dbo].[DomainUser]
WHERE @@ROWCOUNT > 0 AND [DomainUserId] = scope_identity()',N'@0 int,@1 int',@0=1,@1=1
go
exec sp_executesql N'INSERT [dbo].[RoleUser]([IsPrimary], [UserId], [RoleId])
VALUES (@0, @1, @2)
SELECT [RoleUserId]
FROM [dbo].[RoleUser]
WHERE @@ROWCOUNT > 0 AND [RoleUserId] = scope_identity()',N'@0 bit,@1 int,@2 int',@0=1,@1=1,@2=1
go
exec sp_executesql N'INSERT [dbo].[RoleUser]([IsPrimary], [UserId], [RoleId])
VALUES (@0, @1, @2)
SELECT [RoleUserId]
FROM [dbo].[RoleUser]
WHERE @@ROWCOUNT > 0 AND [RoleUserId] = scope_identity()',N'@0 bit,@1 int,@2 int',@0=0,@1=1,@2=2
go
exec sp_executesql N'INSERT [dbo].[RoleUser]([IsPrimary], [UserId], [RoleId])
VALUES (@0, @1, @2)
SELECT [RoleUserId]
FROM [dbo].[RoleUser]
WHERE @@ROWCOUNT > 0 AND [RoleUserId] = scope_identity()',N'@0 bit,@1 int,@2 int',@0=0,@1=1,@2=3
go
exec sp_executesql N'INSERT [dbo].[User]([Name], [Email], [Password], [IsActive], [FirstName], [LastName], [Title], [Gender], [Birthday], [Photo], [PhotoPath], [Note], [HomePhone], [MobilePhone], [WorkPhone], [Position], [Department], [HireDate], [OnlineStatusId], [AddressDetailsId], [DateCreated], [DateLastUpdated])
VALUES (@0, @1, @2, @3, @4, @5, NULL, NULL, NULL, NULL, @6, NULL, NULL, NULL, NULL, @7, @8, NULL, NULL, NULL, @9, @10)
SELECT [UserId]
FROM [dbo].[User]
WHERE @@ROWCOUNT > 0 AND [UserId] = scope_identity()',N'@0 nvarchar(16),@1 nvarchar(256),@2 nvarchar(16),@3 bit,@4 nvarchar(50),@5 nvarchar(50),@6 nvarchar(256),@7 nvarchar(50),@8 nvarchar(50),@9 datetime2(7),@10 datetime2(7)',@0=N'pnewman',@1=N'pnewman@aa.com',@2=N'I/Wn9e+RVG0=',@3=1,@4=N'Paul',@5=N'Newman',@6=N'Images\users\pnewman.jpg',@7=N'Developer',@8=N'IT',@9='2014-05-14 22:33:37.0726601',@10='2014-05-14 22:33:37.0726601'
go
exec sp_executesql N'INSERT [dbo].[DomainUser]([UserId], [DomainId])
VALUES (@0, @1)
SELECT [DomainUserId]
FROM [dbo].[DomainUser]
WHERE @@ROWCOUNT > 0 AND [DomainUserId] = scope_identity()',N'@0 int,@1 int',@0=2,@1=1
go
exec sp_executesql N'INSERT [dbo].[RoleUser]([IsPrimary], [UserId], [RoleId])
VALUES (@0, @1, @2)
SELECT [RoleUserId]
FROM [dbo].[RoleUser]
WHERE @@ROWCOUNT > 0 AND [RoleUserId] = scope_identity()',N'@0 bit,@1 int,@2 int',@0=1,@1=2,@2=4
go
exec sp_executesql N'INSERT [dbo].[RoleUser]([IsPrimary], [UserId], [RoleId])
VALUES (@0, @1, @2)
SELECT [RoleUserId]
FROM [dbo].[RoleUser]
WHERE @@ROWCOUNT > 0 AND [RoleUserId] = scope_identity()',N'@0 bit,@1 int,@2 int',@0=0,@1=2,@2=2
go
exec sp_executesql N'INSERT [dbo].[User]([Name], [Email], [Password], [IsActive], [FirstName], [LastName], [Title], [Gender], [Birthday], [Photo], [PhotoPath], [Note], [HomePhone], [MobilePhone], [WorkPhone], [Position], [Department], [HireDate], [OnlineStatusId], [AddressDetailsId], [DateCreated], [DateLastUpdated])
VALUES (@0, @1, @2, @3, @4, @5, NULL, NULL, NULL, NULL, @6, NULL, NULL, NULL, NULL, @7, @8, NULL, NULL, NULL, @9, @10)
SELECT [UserId]
FROM [dbo].[User]
WHERE @@ROWCOUNT > 0 AND [UserId] = scope_identity()',N'@0 nvarchar(16),@1 nvarchar(256),@2 nvarchar(16),@3 bit,@4 nvarchar(50),@5 nvarchar(50),@6 nvarchar(256),@7 nvarchar(50),@8 nvarchar(50),@9 datetime2(7),@10 datetime2(7)',@0=N'hbogart',@1=N'hbogart@aa.com',@2=N'I/Wn9e+RVG0=',@3=1,@4=N'Humphrey',@5=N'Bogart',@6=N'Images\users\hbogart.jpg',@7=N'Business Analyst Manager',@8=N'Finance',@9='2014-05-14 22:33:37.0726601',@10='2014-05-14 22:33:37.0726601'
go
exec sp_executesql N'INSERT [dbo].[DomainUser]([UserId], [DomainId])
VALUES (@0, @1)
SELECT [DomainUserId]
FROM [dbo].[DomainUser]
WHERE @@ROWCOUNT > 0 AND [DomainUserId] = scope_identity()',N'@0 int,@1 int',@0=3,@1=1
go
exec sp_executesql N'INSERT [dbo].[RoleUser]([IsPrimary], [UserId], [RoleId])
VALUES (@0, @1, @2)
SELECT [RoleUserId]
FROM [dbo].[RoleUser]
WHERE @@ROWCOUNT > 0 AND [RoleUserId] = scope_identity()',N'@0 bit,@1 int,@2 int',@0=1,@1=3,@2=5
go
exec sp_executesql N'INSERT [dbo].[User]([Name], [Email], [Password], [IsActive], [FirstName], [LastName], [Title], [Gender], [Birthday], [Photo], [PhotoPath], [Note], [HomePhone], [MobilePhone], [WorkPhone], [Position], [Department], [HireDate], [OnlineStatusId], [AddressDetailsId], [DateCreated], [DateLastUpdated])
VALUES (@0, @1, @2, @3, @4, @5, NULL, NULL, NULL, NULL, @6, NULL, NULL, NULL, NULL, @7, @8, NULL, NULL, NULL, @9, @10)
SELECT [UserId]
FROM [dbo].[User]
WHERE @@ROWCOUNT > 0 AND [UserId] = scope_identity()',N'@0 nvarchar(16),@1 nvarchar(256),@2 nvarchar(16),@3 bit,@4 nvarchar(50),@5 nvarchar(50),@6 nvarchar(256),@7 nvarchar(50),@8 nvarchar(50),@9 datetime2(7),@10 datetime2(7)',@0=N'knovak',@1=N'knovak@aa.com',@2=N'I/Wn9e+RVG0=',@3=1,@4=N'Kim',@5=N'Novak',@6=N'Images\users\knovak.jpg',@7=N'Business Analyst',@8=N'Finance',@9='2014-05-14 22:33:37.0726601',@10='2014-05-14 22:33:37.0726601'
go
exec sp_executesql N'INSERT [dbo].[DomainUser]([UserId], [DomainId])
VALUES (@0, @1)
SELECT [DomainUserId]
FROM [dbo].[DomainUser]
WHERE @@ROWCOUNT > 0 AND [DomainUserId] = scope_identity()',N'@0 int,@1 int',@0=4,@1=1
go
exec sp_executesql N'INSERT [dbo].[RoleUser]([IsPrimary], [UserId], [RoleId])
VALUES (@0, @1, @2)
SELECT [RoleUserId]
FROM [dbo].[RoleUser]
WHERE @@ROWCOUNT > 0 AND [RoleUserId] = scope_identity()',N'@0 bit,@1 int,@2 int',@0=1,@1=4,@2=6
go
exec sp_executesql N'INSERT [dbo].[User]([Name], [Email], [Password], [IsActive], [FirstName], [LastName], [Title], [Gender], [Birthday], [Photo], [PhotoPath], [Note], [HomePhone], [MobilePhone], [WorkPhone], [Position], [Department], [HireDate], [OnlineStatusId], [AddressDetailsId], [DateCreated], [DateLastUpdated])
VALUES (@0, @1, @2, @3, @4, @5, NULL, NULL, NULL, NULL, @6, NULL, NULL, NULL, NULL, @7, @8, NULL, NULL, NULL, @9, @10)
SELECT [UserId]
FROM [dbo].[User]
WHERE @@ROWCOUNT > 0 AND [UserId] = scope_identity()',N'@0 nvarchar(16),@1 nvarchar(256),@2 nvarchar(16),@3 bit,@4 nvarchar(50),@5 nvarchar(50),@6 nvarchar(256),@7 nvarchar(50),@8 nvarchar(50),@9 datetime2(7),@10 datetime2(7)',@0=N'mmonroe',@1=N'mmonroe@aa.com',@2=N'I/Wn9e+RVG0=',@3=1,@4=N'Marilyn',@5=N'Monroe',@6=N'Images\users\mmonroe.jpg',@7=N'Accountant',@8=N'Finance',@9='2014-05-14 22:33:37.0726601',@10='2014-05-14 22:33:37.0726601'
go
exec sp_executesql N'INSERT [dbo].[DomainUser]([UserId], [DomainId])
VALUES (@0, @1)
SELECT [DomainUserId]
FROM [dbo].[DomainUser]
WHERE @@ROWCOUNT > 0 AND [DomainUserId] = scope_identity()',N'@0 int,@1 int',@0=5,@1=1
go

exec sp_executesql N'INSERT [dbo].[RoleUser]([IsPrimary], [UserId], [RoleId])
VALUES (@0, @1, @2)
SELECT [RoleUserId]
FROM [dbo].[RoleUser]
WHERE @@ROWCOUNT > 0 AND [RoleUserId] = scope_identity()',N'@0 bit,@1 int,@2 int',@0=1,@1=5,@2=7
go
exec sp_executesql N'INSERT [dbo].[User]([Name], [Email], [Password], [IsActive], [FirstName], [LastName], [Title], [Gender], [Birthday], [Photo], [PhotoPath], [Note], [HomePhone], [MobilePhone], [WorkPhone], [Position], [Department], [HireDate], [OnlineStatusId], [AddressDetailsId], [DateCreated], [DateLastUpdated])
VALUES (@0, @1, @2, @3, @4, @5, NULL, NULL, NULL, NULL, @6, NULL, NULL, NULL, NULL, @7, @8, NULL, NULL, NULL, @9, @10)
SELECT [UserId]
FROM [dbo].[User]
WHERE @@ROWCOUNT > 0 AND [UserId] = scope_identity()',N'@0 nvarchar(16),@1 nvarchar(256),@2 nvarchar(16),@3 bit,@4 nvarchar(50),@5 nvarchar(50),@6 nvarchar(256),@7 nvarchar(50),@8 nvarchar(50),@9 datetime2(7),@10 datetime2(7)',@0=N'rredford',@1=N'rredford@aa.com',@2=N'I/Wn9e+RVG0=',@3=1,@4=N'Robert',@5=N'Redford',@6=N'Images\users\rredford.jpg',@7=N'Developer',@8=N'IT',@9='2014-05-14 22:33:37.0726601',@10='2014-05-14 22:33:37.0726601'
go
exec sp_executesql N'INSERT [dbo].[DomainUser]([UserId], [DomainId])
VALUES (@0, @1)
SELECT [DomainUserId]
FROM [dbo].[DomainUser]
WHERE @@ROWCOUNT > 0 AND [DomainUserId] = scope_identity()',N'@0 int,@1 int',@0=6,@1=1
go
exec sp_executesql N'INSERT [dbo].[RoleUser]([IsPrimary], [UserId], [RoleId])
VALUES (@0, @1, @2)
SELECT [RoleUserId]
FROM [dbo].[RoleUser]
WHERE @@ROWCOUNT > 0 AND [RoleUserId] = scope_identity()',N'@0 bit,@1 int,@2 int',@0=1,@1=6,@2=4
go
exec sp_executesql N'INSERT [dbo].[RoleUser]([IsPrimary], [UserId], [RoleId])
VALUES (@0, @1, @2)
SELECT [RoleUserId]
FROM [dbo].[RoleUser]
WHERE @@ROWCOUNT > 0 AND [RoleUserId] = scope_identity()',N'@0 bit,@1 int,@2 int',@0=0,@1=6,@2=2
go
exec sp_executesql N'INSERT [dbo].[User]([Name], [Email], [Password], [IsActive], [FirstName], [LastName], [Title], [Gender], [Birthday], [Photo], [PhotoPath], [Note], [HomePhone], [MobilePhone], [WorkPhone], [Position], [Department], [HireDate], [OnlineStatusId], [AddressDetailsId], [DateCreated], [DateLastUpdated])
VALUES (@0, @1, @2, @3, @4, @5, NULL, NULL, NULL, NULL, @6, NULL, NULL, NULL, NULL, @7, @8, NULL, NULL, NULL, @9, @10)
SELECT [UserId]
FROM [dbo].[User]
WHERE @@ROWCOUNT > 0 AND [UserId] = scope_identity()',N'@0 nvarchar(16),@1 nvarchar(256),@2 nvarchar(16),@3 bit,@4 nvarchar(50),@5 nvarchar(50),@6 nvarchar(256),@7 nvarchar(50),@8 nvarchar(50),@9 datetime2(7),@10 datetime2(7)',@0=N'apacino',@1=N'apacino@aa.com',@2=N'I/Wn9e+RVG0=',@3=1,@4=N'Al',@5=N'Pacino',@6=N'Images\users\apacino.jpg',@7=N'Finance Manager',@8=N'Finance',@9='2014-05-14 22:33:37.0726601',@10='2014-05-14 22:33:37.0726601'
go
exec sp_executesql N'INSERT [dbo].[DomainUser]([UserId], [DomainId])
VALUES (@0, @1)
SELECT [DomainUserId]
FROM [dbo].[DomainUser]
WHERE @@ROWCOUNT > 0 AND [DomainUserId] = scope_identity()',N'@0 int,@1 int',@0=7,@1=1
go
exec sp_executesql N'INSERT [dbo].[RoleUser]([IsPrimary], [UserId], [RoleId])
VALUES (@0, @1, @2)
SELECT [RoleUserId]
FROM [dbo].[RoleUser]
WHERE @@ROWCOUNT > 0 AND [RoleUserId] = scope_identity()',N'@0 bit,@1 int,@2 int',@0=1,@1=7,@2=8
go
exec sp_executesql N'INSERT [dbo].[User]([Name], [Email], [Password], [IsActive], [FirstName], [LastName], [Title], [Gender], [Birthday], [Photo], [PhotoPath], [Note], [HomePhone], [MobilePhone], [WorkPhone], [Position], [Department], [HireDate], [OnlineStatusId], [AddressDetailsId], [DateCreated], [DateLastUpdated])
VALUES (@0, @1, @2, @3, @4, @5, NULL, NULL, NULL, NULL, @6, NULL, NULL, NULL, NULL, @7, @8, NULL, NULL, NULL, @9, @10)
SELECT [UserId]
FROM [dbo].[User]
WHERE @@ROWCOUNT > 0 AND [UserId] = scope_identity()',N'@0 nvarchar(16),@1 nvarchar(256),@2 nvarchar(16),@3 bit,@4 nvarchar(50),@5 nvarchar(50),@6 nvarchar(256),@7 nvarchar(50),@8 nvarchar(50),@9 datetime2(7),@10 datetime2(7)',@0=N'cbronson',@1=N'cbronson@aa.com',@2=N'I/Wn9e+RVG0=',@3=1,@4=N'Charles',@5=N'Bronson',@6=N'Images\users\cbronson.jpg',@7=N'Developer',@8=N'IT',@9='2014-05-14 22:33:37.0726601',@10='2014-05-14 22:33:37.0726601'
go
exec sp_executesql N'INSERT [dbo].[DomainUser]([UserId], [DomainId])
VALUES (@0, @1)
SELECT [DomainUserId]
FROM [dbo].[DomainUser]
WHERE @@ROWCOUNT > 0 AND [DomainUserId] = scope_identity()',N'@0 int,@1 int',@0=8,@1=1
go
exec sp_executesql N'INSERT [dbo].[RoleUser]([IsPrimary], [UserId], [RoleId])
VALUES (@0, @1, @2)
SELECT [RoleUserId]
FROM [dbo].[RoleUser]
WHERE @@ROWCOUNT > 0 AND [RoleUserId] = scope_identity()',N'@0 bit,@1 int,@2 int',@0=1,@1=8,@2=4
go
exec sp_executesql N'INSERT [dbo].[User]([Name], [Email], [Password], [IsActive], [FirstName], [LastName], [Title], [Gender], [Birthday], [Photo], [PhotoPath], [Note], [HomePhone], [MobilePhone], [WorkPhone], [Position], [Department], [HireDate], [OnlineStatusId], [AddressDetailsId], [DateCreated], [DateLastUpdated])
VALUES (@0, @1, @2, @3, @4, @5, NULL, NULL, NULL, NULL, @6, NULL, NULL, NULL, NULL, @7, @8, NULL, NULL, NULL, @9, @10)
SELECT [UserId]
FROM [dbo].[User]
WHERE @@ROWCOUNT > 0 AND [UserId] = scope_identity()',N'@0 nvarchar(16),@1 nvarchar(256),@2 nvarchar(16),@3 bit,@4 nvarchar(50),@5 nvarchar(50),@6 nvarchar(256),@7 nvarchar(50),@8 nvarchar(50),@9 datetime2(7),@10 datetime2(7)',@0=N'dday',@1=N'dday@aa.com',@2=N'I/Wn9e+RVG0=',@3=1,@4=N'Doris',@5=N'Day',@6=N'Images\users\dday.jpg',@7=N'Accountant',@8=N'Finance',@9='2014-05-14 22:33:37.0726601',@10='2014-05-14 22:33:37.0726601'
go
exec sp_executesql N'INSERT [dbo].[DomainUser]([UserId], [DomainId])
VALUES (@0, @1)
SELECT [DomainUserId]
FROM [dbo].[DomainUser]
WHERE @@ROWCOUNT > 0 AND [DomainUserId] = scope_identity()',N'@0 int,@1 int',@0=9,@1=1
go
exec sp_executesql N'INSERT [dbo].[RoleUser]([IsPrimary], [UserId], [RoleId])
VALUES (@0, @1, @2)
SELECT [RoleUserId]
FROM [dbo].[RoleUser]
WHERE @@ROWCOUNT > 0 AND [RoleUserId] = scope_identity()',N'@0 bit,@1 int,@2 int',@0=1,@1=9,@2=7
go
exec sp_executesql N'INSERT [dbo].[User]([Name], [Email], [Password], [IsActive], [FirstName], [LastName], [Title], [Gender], [Birthday], [Photo], [PhotoPath], [Note], [HomePhone], [MobilePhone], [WorkPhone], [Position], [Department], [HireDate], [OnlineStatusId], [AddressDetailsId], [DateCreated], [DateLastUpdated])
VALUES (@0, @1, @2, @3, @4, @5, NULL, NULL, NULL, NULL, @6, NULL, NULL, NULL, NULL, @7, @8, NULL, NULL, NULL, @9, @10)
SELECT [UserId]
FROM [dbo].[User]
WHERE @@ROWCOUNT > 0 AND [UserId] = scope_identity()',N'@0 nvarchar(16),@1 nvarchar(256),@2 nvarchar(16),@3 bit,@4 nvarchar(50),@5 nvarchar(50),@6 nvarchar(256),@7 nvarchar(50),@8 nvarchar(50),@9 datetime2(7),@10 datetime2(7)',@0=N'gkelly',@1=N'gkelly@aa.com',@2=N'I/Wn9e+RVG0=',@3=1,@4=N'Grace',@5=N'Kelly',@6=N'Images\users\gkelly.jpg',@7=N'Business Analyst',@8=N'Finance',@9='2014-05-14 22:33:37.0726601',@10='2014-05-14 22:33:37.0726601'
go
exec sp_executesql N'INSERT [dbo].[DomainUser]([UserId], [DomainId])
VALUES (@0, @1)
SELECT [DomainUserId]
FROM [dbo].[DomainUser]
WHERE @@ROWCOUNT > 0 AND [DomainUserId] = scope_identity()',N'@0 int,@1 int',@0=10,@1=1
go
exec sp_executesql N'INSERT [dbo].[RoleUser]([IsPrimary], [UserId], [RoleId])
VALUES (@0, @1, @2)
SELECT [RoleUserId]
FROM [dbo].[RoleUser]
WHERE @@ROWCOUNT > 0 AND [RoleUserId] = scope_identity()',N'@0 bit,@1 int,@2 int',@0=1,@1=10,@2=6
go
exec sp_executesql N'INSERT [dbo].[User]([Name], [Email], [Password], [IsActive], [FirstName], [LastName], [Title], [Gender], [Birthday], [Photo], [PhotoPath], [Note], [HomePhone], [MobilePhone], [WorkPhone], [Position], [Department], [HireDate], [OnlineStatusId], [AddressDetailsId], [DateCreated], [DateLastUpdated])
VALUES (@0, @1, @2, @3, @4, @5, NULL, NULL, NULL, NULL, @6, NULL, NULL, NULL, NULL, @7, @8, NULL, NULL, NULL, @9, @10)
SELECT [UserId]
FROM [dbo].[User]
WHERE @@ROWCOUNT > 0 AND [UserId] = scope_identity()',N'@0 nvarchar(16),@1 nvarchar(256),@2 nvarchar(16),@3 bit,@4 nvarchar(50),@5 nvarchar(50),@6 nvarchar(256),@7 nvarchar(50),@8 nvarchar(50),@9 datetime2(7),@10 datetime2(7)',@0=N'gpeck',@1=N'gpeck@aa.com',@2=N'I/Wn9e+RVG0=',@3=1,@4=N'Gregory',@5=N'Peck',@6=N'Images\users\gpeck.jpg',@7=N'Project Manager',@8=N'Finance',@9='2014-05-14 22:33:37.0726601',@10='2014-05-14 22:33:37.0726601'
go
exec sp_executesql N'INSERT [dbo].[DomainUser]([UserId], [DomainId])
VALUES (@0, @1)
SELECT [DomainUserId]
FROM [dbo].[DomainUser]
WHERE @@ROWCOUNT > 0 AND [DomainUserId] = scope_identity()',N'@0 int,@1 int',@0=11,@1=1
go
exec sp_executesql N'INSERT [dbo].[RoleUser]([IsPrimary], [UserId], [RoleId])
VALUES (@0, @1, @2)
SELECT [RoleUserId]
FROM [dbo].[RoleUser]
WHERE @@ROWCOUNT > 0 AND [RoleUserId] = scope_identity()',N'@0 bit,@1 int,@2 int',@0=1,@1=11,@2=9
go

exec sp_executesql N'INSERT [dbo].[User]([Name], [Email], [Password], [IsActive], [FirstName], [LastName], [Title], [Gender], [Birthday], [Photo], [PhotoPath], [Note], [HomePhone], [MobilePhone], [WorkPhone], [Position], [Department], [HireDate], [OnlineStatusId], [AddressDetailsId], [DateCreated], [DateLastUpdated])
VALUES (@0, @1, @2, @3, @4, @5, NULL, NULL, NULL, NULL, @6, NULL, NULL, NULL, NULL, @7, @8, NULL, NULL, NULL, @9, @10)
SELECT [UserId]
FROM [dbo].[User]
WHERE @@ROWCOUNT > 0 AND [UserId] = scope_identity()',N'@0 nvarchar(16),@1 nvarchar(256),@2 nvarchar(16),@3 bit,@4 nvarchar(50),@5 nvarchar(50),@6 nvarchar(256),@7 nvarchar(50),@8 nvarchar(50),@9 datetime2(7),@10 datetime2(7)',@0=N'jdean',@1=N'jdean@aa.com',@2=N'I/Wn9e+RVG0=',@3=1,@4=N'James',@5=N'Dean',@6=N'Images\users\jdean.jpg',@7=N'Project Manager',@8=N'IT',@9='2014-05-14 22:33:37.0726601',@10='2014-05-14 22:33:37.0726601'
go
exec sp_executesql N'INSERT [dbo].[DomainUser]([UserId], [DomainId])
VALUES (@0, @1)
SELECT [DomainUserId]
FROM [dbo].[DomainUser]
WHERE @@ROWCOUNT > 0 AND [DomainUserId] = scope_identity()',N'@0 int,@1 int',@0=12,@1=1
go
exec sp_executesql N'INSERT [dbo].[RoleUser]([IsPrimary], [UserId], [RoleId])
VALUES (@0, @1, @2)
SELECT [RoleUserId]
FROM [dbo].[RoleUser]
WHERE @@ROWCOUNT > 0 AND [RoleUserId] = scope_identity()',N'@0 bit,@1 int,@2 int',@0=1,@1=12,@2=9
go
exec sp_executesql N'INSERT [dbo].[User]([Name], [Email], [Password], [IsActive], [FirstName], [LastName], [Title], [Gender], [Birthday], [Photo], [PhotoPath], [Note], [HomePhone], [MobilePhone], [WorkPhone], [Position], [Department], [HireDate], [OnlineStatusId], [AddressDetailsId], [DateCreated], [DateLastUpdated])
VALUES (@0, @1, @2, @3, @4, @5, NULL, NULL, NULL, NULL, @6, NULL, NULL, NULL, NULL, @7, @8, NULL, NULL, NULL, @9, @10)
SELECT [UserId]
FROM [dbo].[User]
WHERE @@ROWCOUNT > 0 AND [UserId] = scope_identity()',N'@0 nvarchar(16),@1 nvarchar(256),@2 nvarchar(16),@3 bit,@4 nvarchar(50),@5 nvarchar(50),@6 nvarchar(256),@7 nvarchar(50),@8 nvarchar(50),@9 datetime2(7),@10 datetime2(7)',@0=N'jstewart',@1=N'jstewart@aa.com',@2=N'I/Wn9e+RVG0=',@3=1,@4=N'James',@5=N'Stewart',@6=N'Images\users\jstewart.jpg',@7=N'PM Manager',@8=N'IT',@9='2014-05-14 22:33:37.0726601',@10='2014-05-14 22:33:37.0726601'
go
exec sp_executesql N'INSERT [dbo].[DomainUser]([UserId], [DomainId])
VALUES (@0, @1)
SELECT [DomainUserId]
FROM [dbo].[DomainUser]
WHERE @@ROWCOUNT > 0 AND [DomainUserId] = scope_identity()',N'@0 int,@1 int',@0=13,@1=1
go
exec sp_executesql N'INSERT [dbo].[RoleUser]([IsPrimary], [UserId], [RoleId])
VALUES (@0, @1, @2)
SELECT [RoleUserId]
FROM [dbo].[RoleUser]
WHERE @@ROWCOUNT > 0 AND [RoleUserId] = scope_identity()',N'@0 bit,@1 int,@2 int',@0=1,@1=13,@2=10
go
exec sp_executesql N'INSERT [dbo].[User]([Name], [Email], [Password], [IsActive], [FirstName], [LastName], [Title], [Gender], [Birthday], [Photo], [PhotoPath], [Note], [HomePhone], [MobilePhone], [WorkPhone], [Position], [Department], [HireDate], [OnlineStatusId], [AddressDetailsId], [DateCreated], [DateLastUpdated])
VALUES (@0, @1, @2, @3, @4, @5, NULL, NULL, NULL, NULL, @6, NULL, NULL, NULL, NULL, @7, @8, NULL, NULL, NULL, @9, @10)
SELECT [UserId]
FROM [dbo].[User]
WHERE @@ROWCOUNT > 0 AND [UserId] = scope_identity()',N'@0 nvarchar(16),@1 nvarchar(256),@2 nvarchar(16),@3 bit,@4 nvarchar(50),@5 nvarchar(50),@6 nvarchar(256),@7 nvarchar(50),@8 nvarchar(50),@9 datetime2(7),@10 datetime2(7)',@0=N'mpfeiffer',@1=N'mpfeiffer@aa.com',@2=N'I/Wn9e+RVG0=',@3=1,@4=N'Michelle',@5=N'Pfeiffer',@6=N'Images\users\mpfeiffer.jpg',@7=N'Business Analyst',@8=N'IT',@9='2014-05-14 22:33:37.0726601',@10='2014-05-14 22:33:37.0726601'
go
exec sp_executesql N'INSERT [dbo].[DomainUser]([UserId], [DomainId])
VALUES (@0, @1)
SELECT [DomainUserId]
FROM [dbo].[DomainUser]
WHERE @@ROWCOUNT > 0 AND [DomainUserId] = scope_identity()',N'@0 int,@1 int',@0=14,@1=1
go
exec sp_executesql N'INSERT [dbo].[RoleUser]([IsPrimary], [UserId], [RoleId])
VALUES (@0, @1, @2)
SELECT [RoleUserId]
FROM [dbo].[RoleUser]
WHERE @@ROWCOUNT > 0 AND [RoleUserId] = scope_identity()',N'@0 bit,@1 int,@2 int',@0=1,@1=14,@2=6
go
exec sp_executesql N'INSERT [dbo].[User]([Name], [Email], [Password], [IsActive], [FirstName], [LastName], [Title], [Gender], [Birthday], [Photo], [PhotoPath], [Note], [HomePhone], [MobilePhone], [WorkPhone], [Position], [Department], [HireDate], [OnlineStatusId], [AddressDetailsId], [DateCreated], [DateLastUpdated])
VALUES (@0, @1, @2, @3, @4, @5, NULL, NULL, NULL, NULL, @6, NULL, NULL, NULL, NULL, @7, @8, NULL, NULL, NULL, @9, @10)
SELECT [UserId]
FROM [dbo].[User]
WHERE @@ROWCOUNT > 0 AND [UserId] = scope_identity()',N'@0 nvarchar(16),@1 nvarchar(256),@2 nvarchar(16),@3 bit,@4 nvarchar(50),@5 nvarchar(50),@6 nvarchar(256),@7 nvarchar(50),@8 nvarchar(50),@9 datetime2(7),@10 datetime2(7)',@0=N'nkidman',@1=N'nkidman@aa.com',@2=N'I/Wn9e+RVG0=',@3=1,@4=N'Nicole',@5=N'Kidman',@6=N'Images\users\nkidman.jpg',@7=N'Human Resources',@8=N'HR',@9='2014-05-14 22:33:37.0726601',@10='2014-05-14 22:33:37.0726601'
go
exec sp_executesql N'INSERT [dbo].[DomainUser]([UserId], [DomainId])
VALUES (@0, @1)
SELECT [DomainUserId]
FROM [dbo].[DomainUser]
WHERE @@ROWCOUNT > 0 AND [DomainUserId] = scope_identity()',N'@0 int,@1 int',@0=15,@1=1
go
exec sp_executesql N'INSERT [dbo].[RoleUser]([IsPrimary], [UserId], [RoleId])
VALUES (@0, @1, @2)
SELECT [RoleUserId]
FROM [dbo].[RoleUser]
WHERE @@ROWCOUNT > 0 AND [RoleUserId] = scope_identity()',N'@0 bit,@1 int,@2 int',@0=1,@1=15,@2=11
go
exec sp_executesql N'INSERT [dbo].[User]([Name], [Email], [Password], [IsActive], [FirstName], [LastName], [Title], [Gender], [Birthday], [Photo], [PhotoPath], [Note], [HomePhone], [MobilePhone], [WorkPhone], [Position], [Department], [HireDate], [OnlineStatusId], [AddressDetailsId], [DateCreated], [DateLastUpdated])
VALUES (@0, @1, @2, @3, @4, @5, NULL, NULL, NULL, NULL, @6, NULL, NULL, NULL, NULL, @7, @8, NULL, NULL, NULL, @9, @10)
SELECT [UserId]
FROM [dbo].[User]
WHERE @@ROWCOUNT > 0 AND [UserId] = scope_identity()',N'@0 nvarchar(16),@1 nvarchar(256),@2 nvarchar(16),@3 bit,@4 nvarchar(50),@5 nvarchar(50),@6 nvarchar(256),@7 nvarchar(50),@8 nvarchar(50),@9 datetime2(7),@10 datetime2(7)',@0=N'rdeniro',@1=N'rdeniro@aa.com',@2=N'I/Wn9e+RVG0=',@3=1,@4=N'Robert',@5=N'Deniro',@6=N'Images\users\rdeniro.jpg',@7=N'Developer',@8=N'IT',@9='2014-05-14 22:33:37.0726601',@10='2014-05-14 22:33:37.0726601'
go
exec sp_executesql N'INSERT [dbo].[DomainUser]([UserId], [DomainId])
VALUES (@0, @1)
SELECT [DomainUserId]
FROM [dbo].[DomainUser]
WHERE @@ROWCOUNT > 0 AND [DomainUserId] = scope_identity()',N'@0 int,@1 int',@0=16,@1=1
go
exec sp_executesql N'INSERT [dbo].[RoleUser]([IsPrimary], [UserId], [RoleId])
VALUES (@0, @1, @2)
SELECT [RoleUserId]
FROM [dbo].[RoleUser]
WHERE @@ROWCOUNT > 0 AND [RoleUserId] = scope_identity()',N'@0 bit,@1 int,@2 int',@0=1,@1=16,@2=4
go
exec sp_executesql N'INSERT [dbo].[RoleUser]([IsPrimary], [UserId], [RoleId])
VALUES (@0, @1, @2)
SELECT [RoleUserId]
FROM [dbo].[RoleUser]
WHERE @@ROWCOUNT > 0 AND [RoleUserId] = scope_identity()',N'@0 bit,@1 int,@2 int',@0=0,@1=16,@2=3
go
exec sp_executesql N'INSERT [dbo].[User]([Name], [Email], [Password], [IsActive], [FirstName], [LastName], [Title], [Gender], [Birthday], [Photo], [PhotoPath], [Note], [HomePhone], [MobilePhone], [WorkPhone], [Position], [Department], [HireDate], [OnlineStatusId], [AddressDetailsId], [DateCreated], [DateLastUpdated])
VALUES (@0, @1, @2, @3, @4, @5, NULL, NULL, NULL, NULL, @6, NULL, NULL, NULL, NULL, @7, @8, NULL, NULL, NULL, @9, @10)
SELECT [UserId]
FROM [dbo].[User]
WHERE @@ROWCOUNT > 0 AND [UserId] = scope_identity()',N'@0 nvarchar(16),@1 nvarchar(256),@2 nvarchar(16),@3 bit,@4 nvarchar(50),@5 nvarchar(50),@6 nvarchar(256),@7 nvarchar(50),@8 nvarchar(50),@9 datetime2(7),@10 datetime2(7)',@0=N'rhayworth',@1=N'rhayworth@aa.com',@2=N'I/Wn9e+RVG0=',@3=1,@4=N'Rita',@5=N'Hayworth',@6=N'Images\users\rhayworth.jpg',@7=N'Project Manager',@8=N'Finance',@9='2014-05-14 22:33:37.0726601',@10='2014-05-14 22:33:37.0726601'
go
exec sp_executesql N'INSERT [dbo].[DomainUser]([UserId], [DomainId])
VALUES (@0, @1)
SELECT [DomainUserId]
FROM [dbo].[DomainUser]
WHERE @@ROWCOUNT > 0 AND [DomainUserId] = scope_identity()',N'@0 int,@1 int',@0=17,@1=1
go
exec sp_executesql N'INSERT [dbo].[RoleUser]([IsPrimary], [UserId], [RoleId])
VALUES (@0, @1, @2)
SELECT [RoleUserId]
FROM [dbo].[RoleUser]
WHERE @@ROWCOUNT > 0 AND [RoleUserId] = scope_identity()',N'@0 bit,@1 int,@2 int',@0=1,@1=17,@2=9
go
exec sp_executesql N'INSERT [dbo].[User]([Name], [Email], [Password], [IsActive], [FirstName], [LastName], [Title], [Gender], [Birthday], [Photo], [PhotoPath], [Note], [HomePhone], [MobilePhone], [WorkPhone], [Position], [Department], [HireDate], [OnlineStatusId], [AddressDetailsId], [DateCreated], [DateLastUpdated])
VALUES (@0, @1, @2, @3, @4, @5, NULL, NULL, NULL, NULL, @6, NULL, NULL, NULL, NULL, @7, @8, NULL, NULL, NULL, @9, @10)
SELECT [UserId]
FROM [dbo].[User]
WHERE @@ROWCOUNT > 0 AND [UserId] = scope_identity()',N'@0 nvarchar(16),@1 nvarchar(256),@2 nvarchar(16),@3 bit,@4 nvarchar(50),@5 nvarchar(50),@6 nvarchar(256),@7 nvarchar(50),@8 nvarchar(50),@9 datetime2(7),@10 datetime2(7)',@0=N'rmitchum',@1=N'rmitchum@aa.com',@2=N'I/Wn9e+RVG0=',@3=1,@4=N'Robert',@5=N'Mitchum',@6=N'Images\users\rmitchum.jpg',@7=N'Developer',@8=N'IT',@9='2014-05-14 22:33:37.0726601',@10='2014-05-14 22:33:37.0726601'
go

exec sp_executesql N'INSERT [dbo].[DomainUser]([UserId], [DomainId])
VALUES (@0, @1)
SELECT [DomainUserId]
FROM [dbo].[DomainUser]
WHERE @@ROWCOUNT > 0 AND [DomainUserId] = scope_identity()',N'@0 int,@1 int',@0=18,@1=1
go
exec sp_executesql N'INSERT [dbo].[RoleUser]([IsPrimary], [UserId], [RoleId])
VALUES (@0, @1, @2)
SELECT [RoleUserId]
FROM [dbo].[RoleUser]
WHERE @@ROWCOUNT > 0 AND [RoleUserId] = scope_identity()',N'@0 bit,@1 int,@2 int',@0=1,@1=18,@2=4
go
exec sp_executesql N'INSERT [dbo].[User]([Name], [Email], [Password], [IsActive], [FirstName], [LastName], [Title], [Gender], [Birthday], [Photo], [PhotoPath], [Note], [HomePhone], [MobilePhone], [WorkPhone], [Position], [Department], [HireDate], [OnlineStatusId], [AddressDetailsId], [DateCreated], [DateLastUpdated])
VALUES (@0, @1, @2, @3, @4, @5, NULL, NULL, NULL, NULL, @6, NULL, NULL, NULL, NULL, @7, @8, NULL, NULL, NULL, @9, @10)
SELECT [UserId]
FROM [dbo].[User]
WHERE @@ROWCOUNT > 0 AND [UserId] = scope_identity()',N'@0 nvarchar(16),@1 nvarchar(256),@2 nvarchar(16),@3 bit,@4 nvarchar(50),@5 nvarchar(50),@6 nvarchar(256),@7 nvarchar(50),@8 nvarchar(50),@9 datetime2(7),@10 datetime2(7)',@0=N'sdee',@1=N'sdee@aa.com',@2=N'I/Wn9e+RVG0=',@3=1,@4=N'Sandra',@5=N'Dee',@6=N'Images\users\sdee.jpg',@7=N'Accountant',@8=N'Finance',@9='2014-05-14 22:33:37.0726601',@10='2014-05-14 22:33:37.0726601'
go
exec sp_executesql N'INSERT [dbo].[DomainUser]([UserId], [DomainId])
VALUES (@0, @1)
SELECT [DomainUserId]
FROM [dbo].[DomainUser]
WHERE @@ROWCOUNT > 0 AND [DomainUserId] = scope_identity()',N'@0 int,@1 int',@0=19,@1=1
go
exec sp_executesql N'INSERT [dbo].[RoleUser]([IsPrimary], [UserId], [RoleId])
VALUES (@0, @1, @2)
SELECT [RoleUserId]
FROM [dbo].[RoleUser]
WHERE @@ROWCOUNT > 0 AND [RoleUserId] = scope_identity()',N'@0 bit,@1 int,@2 int',@0=1,@1=19,@2=7
go
exec sp_executesql N'INSERT [dbo].[User]([Name], [Email], [Password], [IsActive], [FirstName], [LastName], [Title], [Gender], [Birthday], [Photo], [PhotoPath], [Note], [HomePhone], [MobilePhone], [WorkPhone], [Position], [Department], [HireDate], [OnlineStatusId], [AddressDetailsId], [DateCreated], [DateLastUpdated])
VALUES (@0, @1, @2, @3, @4, @5, NULL, NULL, NULL, NULL, @6, NULL, NULL, NULL, NULL, @7, @8, NULL, NULL, NULL, @9, @10)
SELECT [UserId]
FROM [dbo].[User]
WHERE @@ROWCOUNT > 0 AND [UserId] = scope_identity()',N'@0 nvarchar(16),@1 nvarchar(256),@2 nvarchar(16),@3 bit,@4 nvarchar(50),@5 nvarchar(50),@6 nvarchar(256),@7 nvarchar(50),@8 nvarchar(50),@9 datetime2(7),@10 datetime2(7)',@0=N'smcqueen',@1=N'smcqueen@aa.com',@2=N'I/Wn9e+RVG0=',@3=1,@4=N'Steve',@5=N'Mcqueen',@6=N'Images\users\smcqueen.jpg',@7=N'Developer',@8=N'IT',@9='2014-05-14 22:33:37.0726601',@10='2014-05-14 22:33:37.0726601'
go
exec sp_executesql N'INSERT [dbo].[DomainUser]([UserId], [DomainId])
VALUES (@0, @1)
SELECT [DomainUserId]
FROM [dbo].[DomainUser]
WHERE @@ROWCOUNT > 0 AND [DomainUserId] = scope_identity()',N'@0 int,@1 int',@0=20,@1=1
go
exec sp_executesql N'INSERT [dbo].[RoleUser]([IsPrimary], [UserId], [RoleId])
VALUES (@0, @1, @2)
SELECT [RoleUserId]
FROM [dbo].[RoleUser]
WHERE @@ROWCOUNT > 0 AND [RoleUserId] = scope_identity()',N'@0 bit,@1 int,@2 int',@0=1,@1=20,@2=4
go
exec sp_executesql N'INSERT [dbo].[User]([Name], [Email], [Password], [IsActive], [FirstName], [LastName], [Title], [Gender], [Birthday], [Photo], [PhotoPath], [Note], [HomePhone], [MobilePhone], [WorkPhone], [Position], [Department], [HireDate], [OnlineStatusId], [AddressDetailsId], [DateCreated], [DateLastUpdated])
VALUES (@0, @1, @2, @3, @4, @5, NULL, NULL, NULL, NULL, @6, NULL, NULL, NULL, NULL, @7, @8, NULL, NULL, NULL, @9, @10)
SELECT [UserId]
FROM [dbo].[User]
WHERE @@ROWCOUNT > 0 AND [UserId] = scope_identity()',N'@0 nvarchar(16),@1 nvarchar(256),@2 nvarchar(16),@3 bit,@4 nvarchar(50),@5 nvarchar(50),@6 nvarchar(256),@7 nvarchar(50),@8 nvarchar(50),@9 datetime2(7),@10 datetime2(7)',@0=N'tcruise',@1=N'tcruise@aa.com',@2=N'I/Wn9e+RVG0=',@3=1,@4=N'Tom',@5=N'Cruise',@6=N'Images\users\tcruise.jpg',@7=N'Human Resources Manager',@8=N'HR',@9='2014-05-14 22:33:37.0726601',@10='2014-05-14 22:33:37.0726601'
go
exec sp_executesql N'INSERT [dbo].[DomainUser]([UserId], [DomainId])
VALUES (@0, @1)
SELECT [DomainUserId]
FROM [dbo].[DomainUser]
WHERE @@ROWCOUNT > 0 AND [DomainUserId] = scope_identity()',N'@0 int,@1 int',@0=21,@1=1
go
exec sp_executesql N'INSERT [dbo].[RoleUser]([IsPrimary], [UserId], [RoleId])
VALUES (@0, @1, @2)
SELECT [RoleUserId]
FROM [dbo].[RoleUser]
WHERE @@ROWCOUNT > 0 AND [RoleUserId] = scope_identity()',N'@0 bit,@1 int,@2 int',@0=1,@1=21,@2=12
go
exec sp_executesql N'INSERT [dbo].[UserFollowing]([FoolowerUserId], [FollowingUserId])
VALUES (@0, @1)
SELECT [UserFollowingId]
FROM [dbo].[UserFollowing]
WHERE @@ROWCOUNT > 0 AND [UserFollowingId] = scope_identity()',N'@0 int,@1 int',@0=1,@1=2
go
exec sp_executesql N'INSERT [dbo].[UserFollowing]([FoolowerUserId], [FollowingUserId])
VALUES (@0, @1)
SELECT [UserFollowingId]
FROM [dbo].[UserFollowing]
WHERE @@ROWCOUNT > 0 AND [UserFollowingId] = scope_identity()',N'@0 int,@1 int',@0=2,@1=1
go
exec sp_executesql N'INSERT [dbo].[UserFollowing]([FoolowerUserId], [FollowingUserId])
VALUES (@0, @1)
SELECT [UserFollowingId]
FROM [dbo].[UserFollowing]
WHERE @@ROWCOUNT > 0 AND [UserFollowingId] = scope_identity()',N'@0 int,@1 int',@0=1,@1=3
go
exec sp_executesql N'INSERT [dbo].[UserFollowing]([FoolowerUserId], [FollowingUserId])
VALUES (@0, @1)
SELECT [UserFollowingId]
FROM [dbo].[UserFollowing]
WHERE @@ROWCOUNT > 0 AND [UserFollowingId] = scope_identity()',N'@0 int,@1 int',@0=1,@1=4
go
exec sp_executesql N'INSERT [dbo].[UserFollowing]([FoolowerUserId], [FollowingUserId])
VALUES (@0, @1)
SELECT [UserFollowingId]
FROM [dbo].[UserFollowing]
WHERE @@ROWCOUNT > 0 AND [UserFollowingId] = scope_identity()',N'@0 int,@1 int',@0=4,@1=5
go
